Microsoft Access Level 1

Outcomes

Participants will learn the basic skills necessary to use a Microsoft Access Database.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
An introductory windows based spreadsheet package (such as Lotus 123 or Microsoft Excel) is strongly suggested

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Overview of Access Introduction to database concepts and terminology An introduction to Access Database planning and design Creating tables Examining a table Creating a table with the Table Wizard Creating a table in Design View Types of primary keys Working with tables Adding records Modifying the table design Finding and editing records Deleting, adding, and copying records and values Filtering and sorting records Using select queries Selecting fields and sorting records Refining the results of a query Using queries to perform calculations Joining tables in a query

Creating and using forms Creating a form Modifying the form design Using a form to locate and organize information Multiple-table forms Creating and using reports Creating a report Creating a report that contains totals Database maintenance Creating a database Copying objects Using Windows Explorer Compacting a database

Performance-based objectives

• Understand database components within Access
• Design and create Database Tables
• Perform data-entry and navigation within a table